clear all
global filepath "C:\Users\karti\Documents\NSS_Labor_Market\Extracted_NSS"
set more off
cd "$filepath"

use "$filepath\NSS_68\renamed_merged-68-10.dta", clear

****************************************************************
*keep if (NIC_2008<=5 & (status!=41|status!=42|status!=.))

*** Total workers

gen agri_worker = ((status==31|status==71|status==72|status==51) & NIC_2008<=5)

gen cultivator = ((status==11|status==12|status==21|status==61|status==62) & NIC_2008<=5)

gen daily_wage_rate=wage_total/days_eachactivity 

gen ag_daily=daily_wage_rate if (agri_worker==1)

gen cult_daily = daily_wage_rate if (cultivator==1)
*************************************************************
gen ag_days = days_eachactivity if (agri_worker==1)

gen cult_days = days_eachactivity if (cultivator==1)

gen sr= subround
drop subround

rename sector Sector
save "$filepath\NSS_68\agri_cult_68.dta", replace 


* Combine casual wage ag and nonag
gen Ag_Zeros = ag_daily
replace Ag_Zeros = 0 if ag_days  == 0
gen cult_inc_Zeros = cult_days
replace cult_inc_Zeros = 0 if cultivator == 0

** I & P Measure

gen agwage = (Ag_Zeros*ag_days) if agri_worker==1

gen cult_income = (cult_inc_Zeros*cult_days) if cultivator==1


drop Ag_Zeros cult_inc_Zeros

foreach var of varlist agwage cult_income{
replace `var' = 0 if `var'==.
}

collapse (rawsum) agwage cult_income [fw=weight], by(personid)

merge 1:m personid using "$filepath\NSS_68\agri_cult_68.dta"
 bys personid: gen a = _n
 keep if a==1
 
 cap drop st
 
gen st="" 
replace st="Jammu & Kashmir" if state==1
replace st="Himachal Pradesh" if state==2
replace st="Punjab" if state==3
replace st="Haryana" if state==6
replace st="Gujarat" if state==24
replace st="Maharashtra" if state==27
replace st="Bihar United" if (state==10|state==20)
replace st="Uttar Pradesh United" if (state==9|state==5)
replace st="Madhya Pradesh United" if (state==22|state==23)
replace st="Tamil Nadu" if state==33
replace st="Karnataka" if state==29
replace st="Kerala" if state==32
replace st="Andhra Pradesh" if state==28
replace st="Odisha" if state==21
replace st="Assam" if state==18
replace st="Tripura" if state==16
replace st="West Bengal" if state==19
replace st="Rajasthan" if state==8
 
drop state
rename st state

egen new_NSS_code = concat(state B1_v06)

keep personid agwage cult_income state round Sector B1_v06 ///
sex age maritalstatus generaleducation techeducation usual_principal_activity ///
usual_principal_activity_nic srl_no_activity status wage_total hhsize principal_nic ///
principal_nco hhtype religion caste land_owned lp land_cultivated new_state_dist_code weight ///
agri_worker cultivator daily_wage_rate ag_daily cult_daily ag_days cult_days sr new_NSS_code


gen hindu=(religion==1)
gen muslim=(religion==2)
gen r_others = (religion>2 & religion!=.)

gen sc=(caste==2)
gen st=(caste==1)
gen c_others =(caste>2 & caste!=.)

gen married = (maritalstatus==2)


gen noeduc = (generaleducation<=1)

gen female = (sex==2)

rename B1_v06 stateregion

save "$filepath\NSS_68\02_04_final_agri_cult_68.dta", replace

************************************************************************************************************
use "$filepath\NSS_61\renamed_merged-61-10.dta", clear

****************************************************************
*keep if (NIC_98<=5)
*drop if (status==41|status==42|status==.)

*** Total workers

gen agri_worker = ((status==31|status==71|status==72|status==51) & NIC_98<=5)

gen cultivator = ((status==11|status==12|status==21|status==61|status==62) & NIC_98<=5)


***********************************************************************

*** Average wage 
*** Mean Daily Wages
gen days_empl=days_eachactivity/10 // no missing values

gen daily_wage_rate=wage_total/days_empl 

gen ag_daily=daily_wage_rate if (agri_worker==1)

gen cult_daily = daily_wage_rate if (cultivator==1)
*************************************************************
gen ag_days = days_eachactivity if (agri_worker==1)

gen cult_days = days_eachactivity if (cultivator==1)
gen sr= subround
drop subround
rename sector Sector
save "$filepath\NSS_61\agri_cult_61.dta", replace 


* Combine casual wage ag and nonag
gen Ag_Zeros = ag_daily
replace Ag_Zeros = 0 if ag_days  == 0
gen cult_inc_Zeros = cult_days
replace cult_inc_Zeros = 0 if cultivator == 0

** I & P Measure

gen agwage = (Ag_Zeros*ag_days) if agri_worker==1

gen cult_income = (cult_inc_Zeros*cult_days) if cultivator==1


drop Ag_Zeros cult_inc_Zeros

foreach var of varlist agwage cult_income{
replace `var' = 0 if `var'==.
}

collapse (rawsum) agwage cult_income [fw=weight], by(personid)

merge 1:m personid using "$filepath\NSS_61\agri_cult_61.dta"
 bys personid: gen a = _n
 keep if a==1
 
cap drop st

gen st="" 
replace st="Jammu & Kashmir" if state==1
replace st="Himachal Pradesh" if state==2
replace st="Punjab" if state==3
replace st="Haryana" if state==6
replace st="Gujarat" if state==24
replace st="Maharashtra" if state==27
replace st="Bihar United" if (state==10|state==20)
replace st="Uttar Pradesh United" if (state==9|state==5)
replace st="Madhya Pradesh United" if (state==22|state==23)
replace st="Tamil Nadu" if state==33
replace st="Karnataka" if state==29
replace st="Kerala" if state==32
replace st="Andhra Pradesh" if state==28
replace st="Odisha" if state==21
replace st="Assam" if state==18
replace st="Tripura" if state==16
replace st="West Bengal" if state==19
replace st="Rajasthan" if state==8
 
drop state
rename st state


egen new_NSS_code = concat(state stateregion)


keep personid agwage cult_income state round Sector stateregion ///
sex age maritalstatus generaleducation techeducation usual_principal_activity ///
usual_principal_activity_nic srl_no_activity status wage_total hhsize principal_nic ///
principal_nco hhtype religion caste land_owned lp land_cultivated new_state_dist_code weight ///
agri_worker cultivator daily_wage_rate ag_daily cult_daily ag_days cult_days sr new_NSS_code



gen hindu=(religion==1)
gen muslim=(religion==2)
gen r_others = (religion>2 & religion!=.)

gen sc=(caste==2)
gen st=(caste==1)
gen c_others =(caste>2 & caste!=.)

gen married = (maritalstatus==2)


gen noeduc = (generaleducation<=1)

gen female = (sex==2)


save "$filepath\NSS_61\02_04_final_agri_cult_61.dta", replace

************************************************************************************************************
use "$filepath\NSS_64\renamed_merged-64-10.dta", clear

****************************************************************
*keep if (NIC_2004<=5)
*drop if (status==41|status==42|status==.)

*** Total workers

gen agri_worker = ((status==31|status==71|status==72|status==51) & NIC_2004<=5)

gen cultivator = ((status==11|status==12|status==21|status==61|status==62) & NIC_2004<=5)



***********************************************************************

*** Average wage 
*** Mean Daily Wages
gen days_empl=days_eachactivity/10 // no missing values
gen daily_wage_rate = wage_total/days_empl 

gen ag_daily=daily_wage_rate if (agri_worker==1)

gen cult_daily = daily_wage_rate if (cultivator==1)
*************************************************************
gen ag_days = days_eachactivity if (agri_worker==1)

gen cult_days = days_eachactivity if (cultivator==1)

gen sr= subround
drop subround
rename sector Sector
save "$filepath\NSS_64\agri_cult_64.dta", replace 


* Combine casual wage ag and nonag
gen Ag_Zeros = ag_daily
replace Ag_Zeros = 0 if ag_days  == 0
gen cult_inc_Zeros = cult_days
replace cult_inc_Zeros = 0 if cultivator == 0

** I & P Measure

gen agwage = (Ag_Zeros*ag_days) if agri_worker==1

gen cult_income = (cult_inc_Zeros*cult_days) if cultivator==1


drop Ag_Zeros cult_inc_Zeros

foreach var of varlist agwage cult_income{
replace `var' = 0 if `var'==.
}

collapse (rawsum) agwage cult_income [fw=weight], by(personid)

merge 1:m personid using "$filepath\NSS_64\agri_cult_64.dta"
 bys personid: gen a = _n
 keep if a==1
 
cap drop st

gen st="" 
replace st="Jammu & Kashmir" if state==1
replace st="Himachal Pradesh" if state==2
replace st="Punjab" if state==3
replace st="Haryana" if state==6
replace st="Gujarat" if state==24
replace st="Maharashtra" if state==27
replace st="Bihar United" if (state==10|state==20)
replace st="Uttar Pradesh United" if (state==9|state==5)
replace st="Madhya Pradesh United" if (state==22|state==23)
replace st="Tamil Nadu" if state==33
replace st="Karnataka" if state==29
replace st="Kerala" if state==32
replace st="Andhra Pradesh" if state==28
replace st="Odisha" if state==21
replace st="Assam" if state==18
replace st="Tripura" if state==16
replace st="West Bengal" if state==19
replace st="Rajasthan" if state==8
 
drop state
rename st state
egen new_NSS_code = concat(state stateregion)
keep personid agwage cult_income state round Sector stateregion ///
sex age maritalstatus generaleducation techeducation usual_principal_activity ///
usual_principal_activity_nic srl_no_activity status wage_total hhsize principal_nic ///
principal_nco hhtype religion caste land_possessed new_state_dist_code weight ///
agri_worker cultivator daily_wage_rate ag_daily cult_daily ag_days cult_days sr new_NSS_code



gen hindu=(religion==1)
gen muslim=(religion==2)
gen r_others = (religion>2 & religion!=.)

gen sc=(caste==2)
gen st=(caste==1)
gen c_others =(caste>2 & caste!=.)

gen married = (maritalstatus==2)


gen noeduc = (generaleducation<=1)

gen female = (sex==2)

save "$filepath\NSS_64\02_04_final_agri_cult_64.dta", replace

************************************************************************************************************
use "$filepath\NSS_66\renamed_merged-66-10.dta", clear

rename NIC_98 NIC_2004

****************************************************************
*keep if (NIC_2004<=5)
*drop if (status==41|status==42|status==.)

*** Total workers

gen agri_worker = ((status==31|status==71|status==72|status==51) & NIC_2004<=5)

gen cultivator = ((status==11|status==12|status==21|status==61|status==62) & NIC_2004<=5)

***********************************************************************

*** Average wage 
*** Mean Daily Wages
gen days_empl=days_eachactivity/10 // no missing values
gen daily_wage_rate = wage_total/days_empl 

gen ag_daily=daily_wage_rate if (agri_worker==1)

gen cult_daily = daily_wage_rate if (cultivator==1)
*************************************************************
gen ag_days = days_eachactivity if (agri_worker==1)

gen cult_days = days_eachactivity if (cultivator==1)

gen sr= subround
drop subround
rename sector Sector
save "$filepath\NSS_66\agri_cult_66.dta", replace 


* Combine casual wage ag and nonag
gen Ag_Zeros = ag_daily
replace Ag_Zeros = 0 if ag_days  == 0
gen cult_inc_Zeros = cult_days
replace cult_inc_Zeros = 0 if cultivator == 0

** I & P Measure

gen agwage = (Ag_Zeros*ag_days) if agri_worker==1

gen cult_income = (cult_inc_Zeros*cult_days) if cultivator==1


drop Ag_Zeros cult_inc_Zeros

foreach var of varlist agwage cult_income{
replace `var' = 0 if `var'==.
}

collapse (rawsum) agwage cult_income [fw=weight], by(personid)

merge 1:m personid using "$filepath\NSS_66\agri_cult_66.dta"
 bys personid: gen a = _n
 keep if a==1
 
cap drop st
 
 gen st="" 
replace st="Jammu & Kashmir" if state==1
replace st="Himachal Pradesh" if state==2
replace st="Punjab" if state==3
replace st="Haryana" if state==6
replace st="Gujarat" if state==24
replace st="Maharashtra" if state==27
replace st="Bihar United" if (state==10|state==20)
replace st="Uttar Pradesh United" if (state==9|state==5)
replace st="Madhya Pradesh United" if (state==22|state==23)
replace st="Tamil Nadu" if state==33
replace st="Karnataka" if state==29
replace st="Kerala" if state==32
replace st="Andhra Pradesh" if state==28
replace st="Odisha" if state==21
replace st="Assam" if state==18
replace st="Tripura" if state==16
replace st="West Bengal" if state==19
replace st="Rajasthan" if state==8
 
drop state
rename st state
egen new_NSS_code = concat(state stateregion)
keep personid agwage cult_income state round Sector stateregion ///
sex age maritalstatus generaleducation techeducation usual_principal_activity ///
usual_principal_activity_nic srl_no_activity status wage_total hhsize principal_nic ///
principal_nco hhtype religion caste land_owned lp land_cultivated new_state_dist_code weight ///
agri_worker cultivator daily_wage_rate ag_daily cult_daily ag_days cult_days sr new_NSS_code


gen hindu=(religion==1)
gen muslim=(religion==2)
gen r_others = (religion>2 & religion!=.)

gen sc=(caste==2)
gen st=(caste==1)
gen c_others =(caste>2 & caste!=.)

gen married = (maritalstatus==2)


gen noeduc = (generaleducation<=1)

gen female = (sex==2)


save "$filepath\NSS_66\02_04_final_agri_cult_66.dta", replace

***************************************************************************************************************
clear
use "C:\Users\karti\Documents\Data\old_nss\NSS_old_data\43_EUS\02_04_agri_cult.dta", clear

*keep if (NIC_1970=="0")



cap drop wage_rate

gen daily_wage_rate = wage_total/days_empl 

gen ag_daily=daily_wage_rate if (agri_worker==1)

gen cult_daily = daily_wage_rate if (cultivator==1)
*************************************************************
gen ag_days = days_eachactivity if (agri_worker==1)

gen cult_days = days_eachactivity if (cultivator==1)

gen round=43
gen sr= Subround
drop Subround
destring sr, replace
destring Sector, replace
save "$filepath\NSS_43\agri_cult_43.dta", replace 


* Combine casual wage ag and nonag
gen Ag_Zeros = ag_daily
replace Ag_Zeros = 0 if ag_days  == 0
gen cult_inc_Zeros = cult_days
replace cult_inc_Zeros = 0 if cultivator == 0

** I & P Measure

gen agwage = (Ag_Zeros*ag_days) if agri_worker==1

gen cult_income = (cult_inc_Zeros*cult_days) if cultivator==1


drop Ag_Zeros cult_inc_Zeros

foreach var of varlist agwage cult_income{
replace `var' = 0 if `var'==.
}

collapse (rawsum) agwage cult_income [fw=Wgt4_pooled], by(Person_key)

merge 1:m Person_key using "$filepath\NSS_43\agri_cult_43.dta"
 bys Person_key: gen a = _n
 keep if a==1
 
drop _m a

rename Person_key personid

bys Hhold_key: gen hhsize = _N

egen new_state_dist_code = concat(State District)
egen new_NSS_code = concat(State Region)
keep personid agwage cult_income state round Sector Region ///
B4_q4 B4_q5 B4_q6 B4_q7 NIC_1970  status wage_total Wgt4_pooled ///
Activity_Slno ///
B3_q1_Hhsize B3_q3 B3_q4_Relgn B3_q5_Hgrup B3_q7 B3_q8 B3_q11 new_state_dist_code ///
agri_worker cultivator daily_wage_rate ag_daily cult_daily ag_days cult_days sr new_NSS_code



rename Region stateregion
rename B4_q4 sex
rename B4_q5 age
rename B4_q6 maritalstatus
rename B4_q7 generaleducation
rename Activity_Slno srl_no_activity
rename B3_q1_Hhsize hhsize
rename B3_q3 hhtype
rename B3_q4_Relgn religion
rename B3_q5_Hgrup caste
rename B3_q7 land_owned 
rename B3_q8 lp
rename B3_q11 land_cultivated



gen weight=int(Wgt4_pooled)
replace state="Bihar United" if state=="Bihar"
replace state="Madhya Pradesh United" if state=="Madhya Pradesh"
replace state="Uttar Pradesh United" if state=="Uttar Pradesh"

destring religion, replace
drop if caste==";"
destring caste, replace
destring maritalstatus, replace
destring generaleducation, replace
destring sex, replace

gen hindu=(religion==1)
gen muslim=(religion==2)
gen r_others = (religion>2 & religion!=.)



gen sc=(caste==2)
gen st=(caste==1)
gen c_others =(caste>2 & caste!=.)

gen married = (maritalstatus==2)


gen noeduc = (generaleducation<=1)

gen female = (sex==2)

save "$filepath\NSS_43\02_04_final_agri_cult_43.dta", replace

*****************************************************************************************************
clear
use "C:\Users\karti\Documents\Data\old_nss\NSS_old_data\55_EUS\02_04_agri_cult.dta", clear
*keep if NIC_98<=5

cap drop wage_rate

gen daily_wage_rate = wage_total/days_empl 

gen ag_daily=daily_wage_rate if (agri_worker==1)

gen cult_daily = daily_wage_rate if (cultivator==1)
*************************************************************
gen ag_days = days_eachactivity if (agri_worker==1)

gen cult_days = days_eachactivity if (cultivator==1)

gen round=55
gen sr= sub_round
drop sub_round
destring sr, replace
destring Sector, replace
save "$filepath\NSS_55\agri_cult_55.dta", replace 


* Combine casual wage ag and nonag
gen Ag_Zeros = ag_daily
replace Ag_Zeros = 0 if ag_days  == 0
gen cult_inc_Zeros = cult_days
replace cult_inc_Zeros = 0 if cultivator == 0

** I & P Measure

gen agwage = (Ag_Zeros*ag_days) if agri_worker==1

gen cult_income = (cult_inc_Zeros*cult_days) if cultivator==1


drop Ag_Zeros cult_inc_Zeros

foreach var of varlist agwage cult_income{
replace `var' = 0 if `var'==.
}

gen weight=int(Wgt_10_10_1_SR_comb)

collapse (rawsum) agwage cult_income [fw=weight], by(Key_prsn)

merge 1:m Key_prsn using "$filepath\NSS_55\agri_cult_55.dta"
 bys Key_prsn: gen a = _n
 keep if a==1
 
drop _m a

rename Key_prsn personid

bys Key_Hhold_slno: gen hhsize = _N

egen new_state_dist_code = concat(State District)
egen new_NSS_code = concat(State Region)

keep personid agwage cult_income state round Sector Region new_state_dist_code hhsize ///
B53_q2 B53_q3 status NIC_98 wage_total B51_q3 B51_q5 B3_q2 Wgt_10_10_1_SR_comb ///
B3_q3 B3_q4 B3_q6 B3_q7 B3_q8 state agri_worker cultivator ///
days_empl daily_wage_rate cult_daily ag_days cult_days sr new_NSS_code




rename B53_q2 age
rename B53_q3 srl_no_activity

rename B51_q5 usual_principal_activity
rename B3_q2 caste
rename B3_q3 religion
rename B3_q4 hhtype

rename B3_q6 land_owned 
rename B3_q7 lp
rename B3_q8 land_cultivated

gen weight=int(Wgt_10_10_1_SR_comb)
replace state="Bihar United" if state=="Bihar"
replace state="Madhya Pradesh United" if state=="Madhya Pradesh"
replace state="Uttar Pradesh United" if state=="Uttar Pradesh"

destring religion, replace
destring caste, replace
*destring maritalstatus, replace
*destring generaleducation, replace
*destring sex, replace


gen hindu=(religion==1)
gen muslim=(religion==2)
gen r_others = (religion>2 & religion!=.)

gen sc=(caste==2)
gen st=(caste==1)
gen c_others =(caste>2 & caste!=.)

*gen married = (maritalstatus==2)


*gen noeduc = (generaleducation<=1)

*gen female = (sex==2)

save "$filepath\NSS_55\02_04_final_agri_cult_55.dta", replace

***************************************************************************************************************

clear
use "C:\Users\karti\Documents\Data\old_nss\NSS_old_data\50_EUS\02_04_agri_cult.dta", clear
cap drop wage_rate
*keep if NIC_1987=="0"

*egen Key_prsn_slno = concat(Hhold_Key Prsn_slno)

gen daily_wage_rate = wage_total/days_empl 

gen ag_daily=daily_wage_rate if (agri_worker==1)

gen cult_daily = daily_wage_rate if (cultivator==1)
*************************************************************
gen ag_days = days_eachactivity if (agri_worker==1)

gen cult_days = days_eachactivity if (cultivator==1)

gen round=50

gen sr=SubRound
destring sr, replace
drop SubRound 
destring Sector, replace

save "$filepath\NSS_50\agri_cult_50.dta", replace 


* Combine casual wage ag and nonag
gen Ag_Zeros = ag_daily
replace Ag_Zeros = 0 if ag_days  == 0
gen cult_inc_Zeros = cult_days
replace cult_inc_Zeros = 0 if cultivator == 0

** I & P Measure

gen agwage = (Ag_Zeros*ag_days) if agri_worker==1

gen cult_income = (cult_inc_Zeros*cult_days) if cultivator==1


drop Ag_Zeros cult_inc_Zeros

foreach var of varlist agwage cult_income{
replace `var' = 0 if `var'==.
}

gen weight = int(WGT_Pooled)

collapse (rawsum) agwage cult_income [fw=weight], by(Key_prsn_slno)

merge 1:m Key_prsn_slno using "$filepath\NSS_50\agri_cult_50.dta"
 bys Key_prsn_slno: gen a = _n
 keep if a==1
 
drop _m a

rename Key_prsn_slno personid

bys Hhold_Key: gen hhsize = _N

*egen new_state_dist_code = concat(State District)
egen new_NSS_code = concat(State Region)

keep personid agwage cult_income state round Sector hhsize ///
B5_q2 B5_q3 B4_q4 B4_q6 B4_q7 B4_q12 B4_q14 B4_q15 WGT_Pooled ///
B3_q4_relgn_cd B3_q5_sgrup_Cd B3_q7 B3_q12 B3_q16 state agri_worker cultivator ///
days_empl daily_wage_rate cult_daily ag_days cult_days round sr new_NSS_code




rename B5_q2 age
rename B5_q3 srl_no_activity

rename B4_q4 sex
rename B4_q6 maritalstatus
rename B4_q7 generaleducation
rename B4_q12 usual_principal_activity
rename B4_q14 NIC
rename B4_q15 NCO
rename B3_q4_relgn_cd religion
rename B3_q5_sgrup_Cd caste
rename B3_q7 land_owned 
rename B3_q12 lp
rename B3_q16 land_cultivated
gen weight = int(WGT_Pooled)

replace state="Bihar United" if state=="Bihar"
replace state="Madhya Pradesh United" if state=="Madhya Pradesh"
replace state="Uttar Pradesh United" if state=="Uttar Pradesh"

destring religion, replace
destring caste, replace
destring maritalstatus, replace
destring generaleducation, replace
destring sex, replace


gen hindu=(religion==1)
gen muslim=(religion==2)
gen r_others = (religion>2 & religion!=.)

gen sc=(caste==2)
gen st=(caste==1)
gen c_others =(caste>2 & caste!=.)

gen married = (maritalstatus==2)


gen noeduc = (generaleducation<=1)

gen female = (sex==2)

save "$filepath\NSS_50\02_04_final_agri_cult_50.dta", replace

***********************************************************************************************

append using "$filepath\NSS_55\02_04_final_agri_cult_55.dta", force
append using "$filepath\NSS_43\02_04_final_agri_cult_43.dta", force
append using "$filepath\NSS_61\02_04_final_agri_cult_61.dta", force
append using "$filepath\NSS_64\02_04_final_agri_cult_64.dta", force
append using "$filepath\NSS_66\02_04_final_agri_cult_66.dta", force
append using "$filepath\NSS_68\02_04_final_agri_cult_68.dta", force
************************************************************************************************
keep if state=="Assam"|state=="Andhra Pradesh"|state=="Bihar United"|state=="Haryana"|state=="Himachal Pradesh"|state=="Jammu & Kashmir"| ///
state=="Karnataka"|state=="Kerala"|state=="Madhya Pradesh United"|state=="Maharashtra"|state=="Odisha"|state=="Punjab"|state=="Rajasthan"| ///
state=="Tamil Nadu"|state=="Gujarat"|state=="Tripura"| ///
state=="West Bengal"|state=="Uttar Pradesh United"

gen year = 1988 if round==43
replace year = 1994 if round==50
replace year = 2000 if round==55
replace year = 2005 if round==61
replace year = 2008 if round==64
replace year = 2010 if round==66
replace year = 2012 if round==68

save "$filepath\NSS_50\02_04_final_agri_cult_43_68.dta", replace
